package com.peycard.persistence.entities;

import java.io.Serializable;
import javax.persistence.*;

import java.sql.Timestamp;
import java.math.BigDecimal;
import java.util.Set;


/**
 * The persistent class for the USER_LIST database table.
 * 
 */
@Entity
@Table(name="USER_LIST")
@NamedQueries({
	@NamedQuery(name="findUserByPcUser_1", query="SELECT u FROM UserList u WHERE u.pcUser = u.pcuss"),
	@NamedQuery(name="findAllUserLists_1", query="SELECT u FROM UserList u"),
	@NamedQuery(name="findAllUSerListNV_1", query="SELECT u FROM UserList u WHERE u.vinculacions IS EMPTY")
})
public class UserList implements Serializable {
	private static final long serialVersionUID = 1L;

	@Id
	@SequenceGenerator(name="ID_ULIST_GENERATOR", sequenceName="ID_ULIST_GENERATOR")
	@GeneratedValue(strategy=GenerationType.SEQUENCE, generator="ID_ULIST_GENERATOR")
	@Column(name="ID_USER_LIST")
	private long idUserList;

	@Column(name="ACCESS_FIRST")
	private String accessFirst;

	private String address;

	private BigDecimal age;

	@Column(name="CEL_TELEPHONE")
	private String celTelephone;

	private String country;

	private String curp;

	private Timestamp datemodified;

	private String email;

	private String email1;

	private String gender;

	@Column(name="ID_EMPLOYEE")
	private String idEmployee;

	@Column(name="IS_ACTIVE")
	private BigDecimal isActive;

	@Column(name="LAST_NAME")
	private String lastName;

	@Column(name="PC_NAME")
	private String pcName;

	@Column(name="PC_PASSWORD")
	private String pcPassword;

	@Column(name="PC_USER")
	private String pcUser;

	private BigDecimal postalcode;

	private String rfc;

	@Column(name="SAVE_DATA")
	private Timestamp saveData;

	private String state;

	private String telephone;

	private String username;

	//bi-directional many-to-one association to Vinculacion
	@OneToMany(mappedBy="userList")
	private Set<Vinculacion> vinculacions;

    public UserList() {
    }

	public long getIdUserList() {
		return this.idUserList;
	}

	public void setIdUserList(long idUserList) {
		this.idUserList = idUserList;
	}

	public String getAccessFirst() {
		return this.accessFirst;
	}

	public void setAccessFirst(String accessFirst) {
		this.accessFirst = accessFirst;
	}

	public String getAddress() {
		return this.address;
	}

	public void setAddress(String address) {
		this.address = address;
	}

	public BigDecimal getAge() {
		return this.age;
	}

	public void setAge(BigDecimal age) {
		this.age = age;
	}

	public String getCelTelephone() {
		return this.celTelephone;
	}

	public void setCelTelephone(String celTelephone) {
		this.celTelephone = celTelephone;
	}

	public String getCountry() {
		return this.country;
	}

	public void setCountry(String country) {
		this.country = country;
	}

	public String getCurp() {
		return this.curp;
	}

	public void setCurp(String curp) {
		this.curp = curp;
	}

	public Timestamp getDatemodified() {
		return this.datemodified;
	}

	public void setDatemodified(Timestamp datemodified) {
		this.datemodified = datemodified;
	}

	public String getIdEmployee() {
		return idEmployee;
	}

	public void setIdEmployee(String idEmployee) {
		this.idEmployee = idEmployee;
	}

	public String getEmail() {
		return this.email;
	}

	public void setEmail(String email) {
		this.email = email;
	}

	public String getEmail1() {
		return this.email1;
	}

	public void setEmail1(String email1) {
		this.email1 = email1;
	}

	public String getGender() {
		return this.gender;
	}

	public void setGender(String gender) {
		this.gender = gender;
	}

	public BigDecimal getIsActive() {
		return this.isActive;
	}

	public void setIsActive(BigDecimal isActive) {
		this.isActive = isActive;
	}

	public String getLastName() {
		return this.lastName;
	}

	public void setLastName(String lastName) {
		this.lastName = lastName;
	}

	public String getPcName() {
		return this.pcName;
	}

	public void setPcName(String pcName) {
		this.pcName = pcName;
	}

	public String getPcPassword() {
		return this.pcPassword;
	}

	public void setPcPassword(String pcPassword) {
		this.pcPassword = pcPassword;
	}

	public String getPcUser() {
		return this.pcUser;
	}

	public void setPcUser(String pcUser) {
		this.pcUser = pcUser;
	}

	public BigDecimal getPostalcode() {
		return this.postalcode;
	}

	public void setPostalcode(BigDecimal postalcode) {
		this.postalcode = postalcode;
	}

	public String getRfc() {
		return this.rfc;
	}

	public void setRfc(String rfc) {
		this.rfc = rfc;
	}

	public Timestamp getSaveData() {
		return this.saveData;
	}

	public void setSaveData(Timestamp saveData) {
		this.saveData = saveData;
	}

	public String getState() {
		return this.state;
	}

	public void setState(String state) {
		this.state = state;
	}

	public String getTelephone() {
		return this.telephone;
	}

	public void setTelephone(String telephone) {
		this.telephone = telephone;
	}

	public String getUsername() {
		return this.username;
	}

	public void setUsername(String username) {
		this.username = username;
	}
	
	public Set<Vinculacion> getVinculacions() {
		return this.vinculacions;
	}

	public void setVinculacions(Set<Vinculacion> vinculacions) {
		this.vinculacions = vinculacions;
	}
	
}